{
 "metadata": {
  "signature": "sha256:aef1297fc1f53b3f85e1348c7426d8b104a2e4b808358cd2f9c11c78694bb639"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "id": "D77A23E307154D9EA7FF0010D07E14A0",
     "metadata": {},
     "source": [
      "# \u5982\u4f55\u67e5\u9605\u6307\u6570"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "id": "A28FD2B531D9463B86FB9CD27DC36670",
     "input": [
      "import pandas as pd\n",
      "pd.set_option('display.max_rows', None)\n",
      "\n",
      "data = DataAPI.IdxGet(field=[u'secID', u'publishDate', u'secShortName'], pandas=\"1\")\n",
      "print(data.shape)\n",
      "data.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "(3641, 3)"
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n"
       ]
      },
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>secID</th>\n",
        "      <th>publishDate</th>\n",
        "      <th>secShortName</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>000001.ZICN</td>\n",
        "      <td>1991-07-15</td>\n",
        "      <td>\u4e0a\u8bc1\u7efc\u6307</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td>000002.ZICN</td>\n",
        "      <td>1992-02-21</td>\n",
        "      <td>A\u80a1\u6307\u6570</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>000003.ZICN</td>\n",
        "      <td>1992-02-21</td>\n",
        "      <td>B\u80a1\u6307\u6570</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>000004.ZICN</td>\n",
        "      <td>1993-06-01</td>\n",
        "      <td>\u5de5\u4e1a\u6307\u6570</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>000005.ZICN</td>\n",
        "      <td>1993-06-01</td>\n",
        "      <td>\u5546\u4e1a\u6307\u6570</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 4,
       "text": [
        "         secID publishDate secShortName\n",
        "0  000001.ZICN  1991-07-15         \u4e0a\u8bc1\u7efc\u6307\n",
        "1  000002.ZICN  1992-02-21         A\u80a1\u6307\u6570\n",
        "2  000003.ZICN  1992-02-21         B\u80a1\u6307\u6570\n",
        "3  000004.ZICN  1993-06-01         \u5de5\u4e1a\u6307\u6570\n",
        "4  000005.ZICN  1993-06-01         \u5546\u4e1a\u6307\u6570"
       ]
      }
     ]
    },
    {
     "cell_type": "markdown",
     "id": "3869F5B5FEED440BAFD9DD688BBDB39F",
     "metadata": {},
     "source": [
      "# \u5982\u4f55\u5b9a\u5411\u641c\u7d22\u7279\u5b9a\u6307\u6570"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": true,
     "id": "D0F13A4D252D430189F9A145FD94B652",
     "input": [
      "data.secShortName.str.contains(\"\u5238\").sum()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 16,
       "text": [
        "613"
       ]
      }
     ]
    },
    {
     "cell_type": "code",
     "collapsed": true,
     "id": "181561B84191447A8D714B9AAB9CEF85",
     "input": [
      "data[data.secShortName.str.contains(\"50\")] # \"\u8bc1\u5238\", \"50\""
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>secID</th>\n",
        "      <th>publishDate</th>\n",
        "      <th>secShortName</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>000016.ZICN</td>\n",
        "      <td>2004-01-02</td>\n",
        "      <td>\u4e0a\u8bc150</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>46</th>\n",
        "      <td>000050.ZICN</td>\n",
        "      <td>2011-01-04</td>\n",
        "      <td>50\u7b49\u6743</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>48</th>\n",
        "      <td>000052.ZICN</td>\n",
        "      <td>2012-01-09</td>\n",
        "      <td>50\u57fa\u672c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>78</th>\n",
        "      <td>000092.ZICN</td>\n",
        "      <td>2011-05-10</td>\n",
        "      <td>\u8d44\u6e9050</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>86</th>\n",
        "      <td>000100.ZICN</td>\n",
        "      <td>2011-07-01</td>\n",
        "      <td>\u4e0a\u8bc1F500</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>111</th>\n",
        "      <td>000126.ZICN</td>\n",
        "      <td>2011-12-09</td>\n",
        "      <td>\u6d88\u8d3950</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>117</th>\n",
        "      <td>000133.ZICN</td>\n",
        "      <td>2012-04-20</td>\n",
        "      <td>\u4e0a\u8bc1150</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>145</th>\n",
        "      <td>000802.ZICN</td>\n",
        "      <td>2011-11-08</td>\n",
        "      <td>500\u6caa\u5e02</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>147</th>\n",
        "      <td>000804.ZICN</td>\n",
        "      <td>2012-01-09</td>\n",
        "      <td>500\u6ce2\u52a8</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>165</th>\n",
        "      <td>000822.ZICN</td>\n",
        "      <td>2012-07-20</td>\n",
        "      <td>500\u7ea2\u5229</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>173</th>\n",
        "      <td>000830.ZICN</td>\n",
        "      <td>2012-08-06</td>\n",
        "      <td>500\u9ad8\u8d1d</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>174</th>\n",
        "      <td>000831.ZICN</td>\n",
        "      <td>2012-08-06</td>\n",
        "      <td>500\u4f4e\u8d1d</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>191</th>\n",
        "      <td>000855.ZICN</td>\n",
        "      <td>2014-11-03</td>\n",
        "      <td>\u592e\u89c6500</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>198</th>\n",
        "      <td>000905.ZICN</td>\n",
        "      <td>2007-01-15</td>\n",
        "      <td>\u4e2d\u8bc1500</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>217</th>\n",
        "      <td>000925.ZICN</td>\n",
        "      <td>2009-02-26</td>\n",
        "      <td>\u57fa\u672c\u976250</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>274</th>\n",
        "      <td>000982.ZICN</td>\n",
        "      <td>2011-06-13</td>\n",
        "      <td>500\u7b49\u6743</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>342</th>\n",
        "      <td>399310.ZICN</td>\n",
        "      <td>2005-09-05</td>\n",
        "      <td>\u56fd\u8bc150</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>437</th>\n",
        "      <td>399423.XSHE</td>\n",
        "      <td>2015-02-05</td>\n",
        "      <td>\u4e2d\u5173\u675150</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>453</th>\n",
        "      <td>399550.ZICN</td>\n",
        "      <td>2012-06-06</td>\n",
        "      <td>\u592e\u89c650</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>465</th>\n",
        "      <td>399610.ZICN</td>\n",
        "      <td>2010-11-08</td>\n",
        "      <td>TMT50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>480</th>\n",
        "      <td>399625.ZICN</td>\n",
        "      <td>2011-08-15</td>\n",
        "      <td>\u4e2d\u521b500</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>501</th>\n",
        "      <td>399646.ZICN</td>\n",
        "      <td>2012-08-06</td>\n",
        "      <td>\u6df1\u6d88\u8d3950</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>502</th>\n",
        "      <td>399647.ZICN</td>\n",
        "      <td>2012-08-06</td>\n",
        "      <td>\u6df1\u533b\u836f50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>525</th>\n",
        "      <td>399670.ZICN</td>\n",
        "      <td>2013-10-28</td>\n",
        "      <td>\u6df1\u5468\u671f50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>526</th>\n",
        "      <td>399671.ZICN</td>\n",
        "      <td>2013-10-28</td>\n",
        "      <td>\u6df1\u9632\u5fa150</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>527</th>\n",
        "      <td>399672.ZICN</td>\n",
        "      <td>2014-04-10</td>\n",
        "      <td>\u6df1\u7ea2\u522950</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>528</th>\n",
        "      <td>399673.ZICN</td>\n",
        "      <td>2014-06-18</td>\n",
        "      <td>\u521b\u4e1a\u677f50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>562</th>\n",
        "      <td>399802.ZICN</td>\n",
        "      <td>2012-09-05</td>\n",
        "      <td>500\u6df1\u5e02</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>579</th>\n",
        "      <td>399905.ZICN</td>\n",
        "      <td>2007-01-15</td>\n",
        "      <td>\u4e2d\u8bc1500</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>596</th>\n",
        "      <td>399925.ZICN</td>\n",
        "      <td>2009-02-26</td>\n",
        "      <td>\u57fa\u672c\u976250</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>650</th>\n",
        "      <td>399982.ZICN</td>\n",
        "      <td>2011-06-13</td>\n",
        "      <td>500\u7b49\u6743</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>664</th>\n",
        "      <td>801001.ZICN</td>\n",
        "      <td>2004-09-21</td>\n",
        "      <td>\u7533\u4e0750</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1207</th>\n",
        "      <td>930885.OTER</td>\n",
        "      <td>2016-09-20</td>\n",
        "      <td>500\u521b\u65b0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1210</th>\n",
        "      <td>930888.OTER</td>\n",
        "      <td>2016-07-27</td>\n",
        "      <td>500DRC</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1221</th>\n",
        "      <td>930899.OTER</td>\n",
        "      <td>2016-09-12</td>\n",
        "      <td>\u5168\u7403\u6d88\u8d3950</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1222</th>\n",
        "      <td>930900.OTER</td>\n",
        "      <td>2016-09-12</td>\n",
        "      <td>\u5168\u7403\u6d88\u8d3950USD</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1249</th>\n",
        "      <td>930931.OTER</td>\n",
        "      <td>2016-12-22</td>\n",
        "      <td>\u6e2f\u80a1\u901a50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1252</th>\n",
        "      <td>930934.OTER</td>\n",
        "      <td>2016-12-22</td>\n",
        "      <td>\u6e2f\u80a1\u901a50CNY</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1259</th>\n",
        "      <td>930943.OTER</td>\n",
        "      <td>2017-03-31</td>\n",
        "      <td>500\u52a8\u6001\u5bf9\u51b2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1275</th>\n",
        "      <td>930959.OTER</td>\n",
        "      <td>2017-06-01</td>\n",
        "      <td>HKC\u6d77\u591650</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1296</th>\n",
        "      <td>930980.OTER</td>\n",
        "      <td>2017-06-01</td>\n",
        "      <td>HKC\u6d77\u591650CNY</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1301</th>\n",
        "      <td>930985.OTER</td>\n",
        "      <td>2017-05-31</td>\n",
        "      <td>500 LBLV</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1325</th>\n",
        "      <td>950090.OTER</td>\n",
        "      <td>2015-11-18</td>\n",
        "      <td>50AH\u4f18\u9009</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1326</th>\n",
        "      <td>950090.XSHG</td>\n",
        "      <td>2015-12-10</td>\n",
        "      <td>\u4e0a\u8bc150\u4f18\u9009</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2664</th>\n",
        "      <td>CBB00101.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u796850\u603b\u503c\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2665</th>\n",
        "      <td>CBB00102.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u796850\u603b\u503c\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2666</th>\n",
        "      <td>CBB00111.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968501\u5e74\u4ee5\u4e0b\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2667</th>\n",
        "      <td>CBB00112.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968501\u5e74\u4ee5\u4e0b\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2668</th>\n",
        "      <td>CBB00113.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968501\u5e74\u4ee5\u4e0b\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2669</th>\n",
        "      <td>CBB00121.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968501-3\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2670</th>\n",
        "      <td>CBB00122.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968501-3\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2671</th>\n",
        "      <td>CBB00123.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968501-3\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2672</th>\n",
        "      <td>CBB00131.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968503-5\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2673</th>\n",
        "      <td>CBB00132.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968503-5\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2674</th>\n",
        "      <td>CBB00133.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968503-5\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2675</th>\n",
        "      <td>CBB00141.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968505-7\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2676</th>\n",
        "      <td>CBB00142.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968505-7\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2677</th>\n",
        "      <td>CBB00143.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968505-7\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2678</th>\n",
        "      <td>CBB00151.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968507-10\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2679</th>\n",
        "      <td>CBB00152.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968507-10\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2680</th>\n",
        "      <td>CBB00153.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u7968507-10\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2681</th>\n",
        "      <td>CBB00161.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u79685010\u5e74\u4ee5\u4e0a\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2682</th>\n",
        "      <td>CBB00162.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u79685010\u5e74\u4ee5\u4e0a\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2683</th>\n",
        "      <td>CBB00163.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u79685010\u5e74\u4ee5\u4e0a\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2684</th>\n",
        "      <td>CBB00201.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d50\u603b\u503c\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2685</th>\n",
        "      <td>CBB00202.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d50\u603b\u503c\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2686</th>\n",
        "      <td>CBB00211.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d501\u5e74\u4ee5\u4e0b\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2687</th>\n",
        "      <td>CBB00212.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d501\u5e74\u4ee5\u4e0b\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2688</th>\n",
        "      <td>CBB00213.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d501\u5e74\u4ee5\u4e0b\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2689</th>\n",
        "      <td>CBB00221.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d501-3\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2690</th>\n",
        "      <td>CBB00222.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d501-3\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2691</th>\n",
        "      <td>CBB00223.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d501-3\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2692</th>\n",
        "      <td>CBB00231.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d503-5\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2693</th>\n",
        "      <td>CBB00232.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d503-5\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2694</th>\n",
        "      <td>CBB00233.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d503-5\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2695</th>\n",
        "      <td>CBB00241.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d505-7\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2696</th>\n",
        "      <td>CBB00242.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d505-7\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2697</th>\n",
        "      <td>CBB00243.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d505-7\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2698</th>\n",
        "      <td>CBB00251.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d507-10\u5e74\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2699</th>\n",
        "      <td>CBB00252.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d507-10\u5e74\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2700</th>\n",
        "      <td>CBB00253.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d507-10\u5e74\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2701</th>\n",
        "      <td>CBB00261.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d5010\u5e74\u4ee5\u4e0a\u8d22\u5bcc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2702</th>\n",
        "      <td>CBB00262.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d5010\u5e74\u4ee5\u4e0a\u51c0\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2703</th>\n",
        "      <td>CBB00263.XIBE</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d5010\u5e74\u4ee5\u4e0a\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2898</th>\n",
        "      <td>DY0036.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u519c\u6797\u7267\u6e14</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2899</th>\n",
        "      <td>DY0037.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u91c7\u6398</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2900</th>\n",
        "      <td>DY0038.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u5316\u5de5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2901</th>\n",
        "      <td>DY0039.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u94a2\u94c1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2902</th>\n",
        "      <td>DY0040.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u6709\u8272\u91d1\u5c5e</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2903</th>\n",
        "      <td>DY0041.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u5efa\u7b51\u6750\u6599</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2904</th>\n",
        "      <td>DY0042.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u5efa\u7b51\u88c5\u9970</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2905</th>\n",
        "      <td>DY0043.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u7535\u6c14\u8bbe\u5907</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2906</th>\n",
        "      <td>DY0044.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u673a\u68b0\u8bbe\u5907</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2907</th>\n",
        "      <td>DY0045.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u56fd\u9632\u519b\u5de5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2908</th>\n",
        "      <td>DY0046.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u6c7d\u8f66</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2909</th>\n",
        "      <td>DY0047.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u7535\u5b50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2910</th>\n",
        "      <td>DY0048.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u5bb6\u7528\u7535\u5668</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2911</th>\n",
        "      <td>DY0049.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u98df\u54c1\u996e\u6599</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2912</th>\n",
        "      <td>DY0050.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u7eba\u7ec7\u670d\u88c5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2913</th>\n",
        "      <td>DY0051.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u8f7b\u5de5\u5236\u9020</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2914</th>\n",
        "      <td>DY0052.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u533b\u836f\u751f\u7269</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2915</th>\n",
        "      <td>DY0053.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u516c\u7528\u4e8b\u4e1a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2916</th>\n",
        "      <td>DY0054.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u4ea4\u901a\u8fd0\u8f93</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2917</th>\n",
        "      <td>DY0055.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u623f\u5730\u4ea7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2918</th>\n",
        "      <td>DY0056.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2919</th>\n",
        "      <td>DY0057.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u975e\u94f6\u91d1\u878d</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2920</th>\n",
        "      <td>DY0058.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u5546\u4e1a\u8d38\u6613</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2921</th>\n",
        "      <td>DY0059.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u4f11\u95f2\u670d\u52a1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2922</th>\n",
        "      <td>DY0060.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u8ba1\u7b97\u673a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2923</th>\n",
        "      <td>DY0061.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u4f20\u5a92</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2924</th>\n",
        "      <td>DY0062.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u901a\u4fe1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2925</th>\n",
        "      <td>DY0063.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u7efc\u5408</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2926</th>\n",
        "      <td>DY0064.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u5efa\u7b51\u5efa\u6750</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2927</th>\n",
        "      <td>DY0065.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u673a\u68b0\u8bbe\u5907</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2928</th>\n",
        "      <td>DY0066.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u4ea4\u8fd0\u8bbe\u5907</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2929</th>\n",
        "      <td>DY0067.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u4fe1\u606f\u8bbe\u5907</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2930</th>\n",
        "      <td>DY0068.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u91d1\u878d\u670d\u52a1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2931</th>\n",
        "      <td>DY0069.ZICN</td>\n",
        "      <td>2017-08-24</td>\n",
        "      <td>\u4e2d\u8bc1500-\u7533\u4e07\u4fe1\u606f\u670d\u52a1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3000</th>\n",
        "      <td>DYCB24.ZICN</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u592e\u796850\u603b\u503c\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3008</th>\n",
        "      <td>DYCB31.ZICN</td>\n",
        "      <td>2007-04-19</td>\n",
        "      <td>\u4e2d\u503a\u77ed\u878d50\u603b\u503c\u5168\u4ef7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3063</th>\n",
        "      <td>H20782.OTER</td>\n",
        "      <td>2016-01-13</td>\n",
        "      <td>500SNLV\u5168\u6536\u76ca</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3158</th>\n",
        "      <td>H20885.OTER</td>\n",
        "      <td>2016-09-20</td>\n",
        "      <td>500\u521b\u65b0\u5168\u6536\u76ca</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3159</th>\n",
        "      <td>H20899.OTER</td>\n",
        "      <td>2016-09-12</td>\n",
        "      <td>\u5168\u7403\u6d88\u8d3950(\u5168)</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3160</th>\n",
        "      <td>H20900.OTER</td>\n",
        "      <td>2016-09-12</td>\n",
        "      <td>\u5168\u7403\u6d88\u8d3950(\u5168)USD</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3185</th>\n",
        "      <td>H20931.OTER</td>\n",
        "      <td>2016-12-22</td>\n",
        "      <td>\u6e2f\u80a1\u901a50(\u5168)</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3188</th>\n",
        "      <td>H20934.OTER</td>\n",
        "      <td>2016-12-22</td>\n",
        "      <td>\u6e2f\u80a1\u901a50(\u5168)CNY</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3201</th>\n",
        "      <td>H20959.OTER</td>\n",
        "      <td>2017-06-01</td>\n",
        "      <td>HKC\u6d77\u591650(\u5168)</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3222</th>\n",
        "      <td>H20980.OTER</td>\n",
        "      <td>2017-06-01</td>\n",
        "      <td>HKC\u6d77\u591650(\u5168)CNY</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3227</th>\n",
        "      <td>H20985.OTER</td>\n",
        "      <td>2017-05-31</td>\n",
        "      <td>500 LBLV\u5168\u6536\u76ca</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3267</th>\n",
        "      <td>H30251.OTER</td>\n",
        "      <td>2013-10-15</td>\n",
        "      <td>500\u539f\u6599</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3268</th>\n",
        "      <td>H30251.ZICN</td>\n",
        "      <td>2013-11-06</td>\n",
        "      <td>500\u539f\u6599</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3269</th>\n",
        "      <td>H30252.OTER</td>\n",
        "      <td>2013-10-15</td>\n",
        "      <td>500\u5de5\u4e1a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3270</th>\n",
        "      <td>H30252.ZICN</td>\n",
        "      <td>2013-11-06</td>\n",
        "      <td>500\u5de5\u4e1a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3271</th>\n",
        "      <td>H30255.OTER</td>\n",
        "      <td>2013-10-15</td>\n",
        "      <td>500\u533b\u836f</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3272</th>\n",
        "      <td>H30255.ZICN</td>\n",
        "      <td>2013-11-06</td>\n",
        "      <td>500\u533b\u836f</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3273</th>\n",
        "      <td>H30257.OTER</td>\n",
        "      <td>2013-10-15</td>\n",
        "      <td>500\u4fe1\u606f</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3274</th>\n",
        "      <td>H30257.ZICN</td>\n",
        "      <td>2013-11-06</td>\n",
        "      <td>500\u4fe1\u606f</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3278</th>\n",
        "      <td>H30318.ZICN</td>\n",
        "      <td>2014-04-15</td>\n",
        "      <td>TMT150</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3302</th>\n",
        "      <td>HSC50.XHKG</td>\n",
        "      <td>2008-06-30</td>\n",
        "      <td>\u6052\u751f\u795e\u5dde50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3308</th>\n",
        "      <td>HSCAT500.XHKG</td>\n",
        "      <td>NaN</td>\n",
        "      <td>\u6052\u751fA\u80a1500\u5f3a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3513</th>\n",
        "      <td>NIFTY.XNSE</td>\n",
        "      <td>NaN</td>\n",
        "      <td>\u5370\u5ea6Nifty 50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3623</th>\n",
        "      <td>SPX.ZIUS</td>\n",
        "      <td>NaN</td>\n",
        "      <td>\u6807\u666e500</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3624</th>\n",
        "      <td>SPXNT.ZIUS</td>\n",
        "      <td>NaN</td>\n",
        "      <td>\u6807\u666e500\u51c0\u603b\u6536\u76ca</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3625</th>\n",
        "      <td>SX5E.XXSC</td>\n",
        "      <td>NaN</td>\n",
        "      <td>\u65af\u6258\u514b50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3636</th>\n",
        "      <td>VIX.XCBO</td>\n",
        "      <td>NaN</td>\n",
        "      <td>S&amp;P 500 VIX</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 14,
       "text": [
        "              secID publishDate   secShortName\n",
        "14      000016.ZICN  2004-01-02           \u4e0a\u8bc150\n",
        "46      000050.ZICN  2011-01-04           50\u7b49\u6743\n",
        "48      000052.ZICN  2012-01-09           50\u57fa\u672c\n",
        "78      000092.ZICN  2011-05-10           \u8d44\u6e9050\n",
        "86      000100.ZICN  2011-07-01         \u4e0a\u8bc1F500\n",
        "111     000126.ZICN  2011-12-09           \u6d88\u8d3950\n",
        "117     000133.ZICN  2012-04-20          \u4e0a\u8bc1150\n",
        "145     000802.ZICN  2011-11-08          500\u6caa\u5e02\n",
        "147     000804.ZICN  2012-01-09          500\u6ce2\u52a8\n",
        "165     000822.ZICN  2012-07-20          500\u7ea2\u5229\n",
        "173     000830.ZICN  2012-08-06          500\u9ad8\u8d1d\n",
        "174     000831.ZICN  2012-08-06          500\u4f4e\u8d1d\n",
        "191     000855.ZICN  2014-11-03          \u592e\u89c6500\n",
        "198     000905.ZICN  2007-01-15          \u4e2d\u8bc1500\n",
        "217     000925.ZICN  2009-02-26          \u57fa\u672c\u976250\n",
        "274     000982.ZICN  2011-06-13          500\u7b49\u6743\n",
        "342     399310.ZICN  2005-09-05           \u56fd\u8bc150\n",
        "437     399423.XSHE  2015-02-05          \u4e2d\u5173\u675150\n",
        "453     399550.ZICN  2012-06-06           \u592e\u89c650\n",
        "465     399610.ZICN  2010-11-08          TMT50\n",
        "480     399625.ZICN  2011-08-15          \u4e2d\u521b500\n",
        "501     399646.ZICN  2012-08-06          \u6df1\u6d88\u8d3950\n",
        "502     399647.ZICN  2012-08-06          \u6df1\u533b\u836f50\n",
        "525     399670.ZICN  2013-10-28          \u6df1\u5468\u671f50\n",
        "526     399671.ZICN  2013-10-28          \u6df1\u9632\u5fa150\n",
        "527     399672.ZICN  2014-04-10          \u6df1\u7ea2\u522950\n",
        "528     399673.ZICN  2014-06-18          \u521b\u4e1a\u677f50\n",
        "562     399802.ZICN  2012-09-05          500\u6df1\u5e02\n",
        "579     399905.ZICN  2007-01-15          \u4e2d\u8bc1500\n",
        "596     399925.ZICN  2009-02-26          \u57fa\u672c\u976250\n",
        "650     399982.ZICN  2011-06-13          500\u7b49\u6743\n",
        "664     801001.ZICN  2004-09-21           \u7533\u4e0750\n",
        "1207    930885.OTER  2016-09-20          500\u521b\u65b0\n",
        "1210    930888.OTER  2016-07-27         500DRC\n",
        "1221    930899.OTER  2016-09-12         \u5168\u7403\u6d88\u8d3950\n",
        "1222    930900.OTER  2016-09-12      \u5168\u7403\u6d88\u8d3950USD\n",
        "1249    930931.OTER  2016-12-22          \u6e2f\u80a1\u901a50\n",
        "1252    930934.OTER  2016-12-22       \u6e2f\u80a1\u901a50CNY\n",
        "1259    930943.OTER  2017-03-31        500\u52a8\u6001\u5bf9\u51b2\n",
        "1275    930959.OTER  2017-06-01        HKC\u6d77\u591650\n",
        "1296    930980.OTER  2017-06-01     HKC\u6d77\u591650CNY\n",
        "1301    930985.OTER  2017-05-31       500 LBLV\n",
        "1325    950090.OTER  2015-11-18         50AH\u4f18\u9009\n",
        "1326    950090.XSHG  2015-12-10         \u4e0a\u8bc150\u4f18\u9009\n",
        "2664  CBB00101.XIBE  2007-04-19     \u4e2d\u503a\u592e\u796850\u603b\u503c\u8d22\u5bcc\n",
        "2665  CBB00102.XIBE  2007-04-19     \u4e2d\u503a\u592e\u796850\u603b\u503c\u51c0\u4ef7\n",
        "2666  CBB00111.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968501\u5e74\u4ee5\u4e0b\u8d22\u5bcc\n",
        "2667  CBB00112.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968501\u5e74\u4ee5\u4e0b\u51c0\u4ef7\n",
        "2668  CBB00113.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968501\u5e74\u4ee5\u4e0b\u5168\u4ef7\n",
        "2669  CBB00121.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968501-3\u5e74\u8d22\u5bcc\n",
        "2670  CBB00122.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968501-3\u5e74\u51c0\u4ef7\n",
        "2671  CBB00123.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968501-3\u5e74\u5168\u4ef7\n",
        "2672  CBB00131.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968503-5\u5e74\u8d22\u5bcc\n",
        "2673  CBB00132.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968503-5\u5e74\u51c0\u4ef7\n",
        "2674  CBB00133.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968503-5\u5e74\u5168\u4ef7\n",
        "2675  CBB00141.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968505-7\u5e74\u8d22\u5bcc\n",
        "2676  CBB00142.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968505-7\u5e74\u51c0\u4ef7\n",
        "2677  CBB00143.XIBE  2007-04-19   \u4e2d\u503a\u592e\u7968505-7\u5e74\u5168\u4ef7\n",
        "2678  CBB00151.XIBE  2007-04-19  \u4e2d\u503a\u592e\u7968507-10\u5e74\u8d22\u5bcc\n",
        "2679  CBB00152.XIBE  2007-04-19  \u4e2d\u503a\u592e\u7968507-10\u5e74\u51c0\u4ef7\n",
        "2680  CBB00153.XIBE  2007-04-19  \u4e2d\u503a\u592e\u7968507-10\u5e74\u5168\u4ef7\n",
        "2681  CBB00161.XIBE  2007-04-19  \u4e2d\u503a\u592e\u79685010\u5e74\u4ee5\u4e0a\u8d22\u5bcc\n",
        "2682  CBB00162.XIBE  2007-04-19  \u4e2d\u503a\u592e\u79685010\u5e74\u4ee5\u4e0a\u51c0\u4ef7\n",
        "2683  CBB00163.XIBE  2007-04-19  \u4e2d\u503a\u592e\u79685010\u5e74\u4ee5\u4e0a\u5168\u4ef7\n",
        "2684  CBB00201.XIBE  2007-04-19     \u4e2d\u503a\u77ed\u878d50\u603b\u503c\u8d22\u5bcc\n",
        "2685  CBB00202.XIBE  2007-04-19     \u4e2d\u503a\u77ed\u878d50\u603b\u503c\u51c0\u4ef7\n",
        "2686  CBB00211.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d501\u5e74\u4ee5\u4e0b\u8d22\u5bcc\n",
        "2687  CBB00212.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d501\u5e74\u4ee5\u4e0b\u51c0\u4ef7\n",
        "2688  CBB00213.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d501\u5e74\u4ee5\u4e0b\u5168\u4ef7\n",
        "2689  CBB00221.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d501-3\u5e74\u8d22\u5bcc\n",
        "2690  CBB00222.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d501-3\u5e74\u51c0\u4ef7\n",
        "2691  CBB00223.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d501-3\u5e74\u5168\u4ef7\n",
        "2692  CBB00231.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d503-5\u5e74\u8d22\u5bcc\n",
        "2693  CBB00232.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d503-5\u5e74\u51c0\u4ef7\n",
        "2694  CBB00233.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d503-5\u5e74\u5168\u4ef7\n",
        "2695  CBB00241.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d505-7\u5e74\u8d22\u5bcc\n",
        "2696  CBB00242.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d505-7\u5e74\u51c0\u4ef7\n",
        "2697  CBB00243.XIBE  2007-04-19   \u4e2d\u503a\u77ed\u878d505-7\u5e74\u5168\u4ef7\n",
        "2698  CBB00251.XIBE  2007-04-19  \u4e2d\u503a\u77ed\u878d507-10\u5e74\u8d22\u5bcc\n",
        "2699  CBB00252.XIBE  2007-04-19  \u4e2d\u503a\u77ed\u878d507-10\u5e74\u51c0\u4ef7\n",
        "2700  CBB00253.XIBE  2007-04-19  \u4e2d\u503a\u77ed\u878d507-10\u5e74\u5168\u4ef7\n",
        "2701  CBB00261.XIBE  2007-04-19  \u4e2d\u503a\u77ed\u878d5010\u5e74\u4ee5\u4e0a\u8d22\u5bcc\n",
        "2702  CBB00262.XIBE  2007-04-19  \u4e2d\u503a\u77ed\u878d5010\u5e74\u4ee5\u4e0a\u51c0\u4ef7\n",
        "2703  CBB00263.XIBE  2007-04-19  \u4e2d\u503a\u77ed\u878d5010\u5e74\u4ee5\u4e0a\u5168\u4ef7\n",
        "2898    DY0036.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u519c\u6797\u7267\u6e14\n",
        "2899    DY0037.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u91c7\u6398\n",
        "2900    DY0038.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u5316\u5de5\n",
        "2901    DY0039.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u94a2\u94c1\n",
        "2902    DY0040.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u6709\u8272\u91d1\u5c5e\n",
        "2903    DY0041.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u5efa\u7b51\u6750\u6599\n",
        "2904    DY0042.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u5efa\u7b51\u88c5\u9970\n",
        "2905    DY0043.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u7535\u6c14\u8bbe\u5907\n",
        "2906    DY0044.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u673a\u68b0\u8bbe\u5907\n",
        "2907    DY0045.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u56fd\u9632\u519b\u5de5\n",
        "2908    DY0046.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u6c7d\u8f66\n",
        "2909    DY0047.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u7535\u5b50\n",
        "2910    DY0048.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u5bb6\u7528\u7535\u5668\n",
        "2911    DY0049.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u98df\u54c1\u996e\u6599\n",
        "2912    DY0050.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u7eba\u7ec7\u670d\u88c5\n",
        "2913    DY0051.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u8f7b\u5de5\u5236\u9020\n",
        "2914    DY0052.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u533b\u836f\u751f\u7269\n",
        "2915    DY0053.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u516c\u7528\u4e8b\u4e1a\n",
        "2916    DY0054.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u4ea4\u901a\u8fd0\u8f93\n",
        "2917    DY0055.ZICN  2017-08-24    \u4e2d\u8bc1500-\u7533\u4e07\u623f\u5730\u4ea7\n",
        "2918    DY0056.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u94f6\u884c\n",
        "2919    DY0057.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u975e\u94f6\u91d1\u878d\n",
        "2920    DY0058.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u5546\u4e1a\u8d38\u6613\n",
        "2921    DY0059.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u4f11\u95f2\u670d\u52a1\n",
        "2922    DY0060.ZICN  2017-08-24    \u4e2d\u8bc1500-\u7533\u4e07\u8ba1\u7b97\u673a\n",
        "2923    DY0061.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u4f20\u5a92\n",
        "2924    DY0062.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u901a\u4fe1\n",
        "2925    DY0063.ZICN  2017-08-24     \u4e2d\u8bc1500-\u7533\u4e07\u7efc\u5408\n",
        "2926    DY0064.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u5efa\u7b51\u5efa\u6750\n",
        "2927    DY0065.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u673a\u68b0\u8bbe\u5907\n",
        "2928    DY0066.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u4ea4\u8fd0\u8bbe\u5907\n",
        "2929    DY0067.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u4fe1\u606f\u8bbe\u5907\n",
        "2930    DY0068.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u91d1\u878d\u670d\u52a1\n",
        "2931    DY0069.ZICN  2017-08-24   \u4e2d\u8bc1500-\u7533\u4e07\u4fe1\u606f\u670d\u52a1\n",
        "3000    DYCB24.ZICN  2007-04-19     \u4e2d\u503a\u592e\u796850\u603b\u503c\u5168\u4ef7\n",
        "3008    DYCB31.ZICN  2007-04-19     \u4e2d\u503a\u77ed\u878d50\u603b\u503c\u5168\u4ef7\n",
        "3063    H20782.OTER  2016-01-13     500SNLV\u5168\u6536\u76ca\n",
        "3158    H20885.OTER  2016-09-20       500\u521b\u65b0\u5168\u6536\u76ca\n",
        "3159    H20899.OTER  2016-09-12      \u5168\u7403\u6d88\u8d3950(\u5168)\n",
        "3160    H20900.OTER  2016-09-12   \u5168\u7403\u6d88\u8d3950(\u5168)USD\n",
        "3185    H20931.OTER  2016-12-22       \u6e2f\u80a1\u901a50(\u5168)\n",
        "3188    H20934.OTER  2016-12-22    \u6e2f\u80a1\u901a50(\u5168)CNY\n",
        "3201    H20959.OTER  2017-06-01     HKC\u6d77\u591650(\u5168)\n",
        "3222    H20980.OTER  2017-06-01  HKC\u6d77\u591650(\u5168)CNY\n",
        "3227    H20985.OTER  2017-05-31    500 LBLV\u5168\u6536\u76ca\n",
        "3267    H30251.OTER  2013-10-15          500\u539f\u6599\n",
        "3268    H30251.ZICN  2013-11-06          500\u539f\u6599\n",
        "3269    H30252.OTER  2013-10-15          500\u5de5\u4e1a\n",
        "3270    H30252.ZICN  2013-11-06          500\u5de5\u4e1a\n",
        "3271    H30255.OTER  2013-10-15          500\u533b\u836f\n",
        "3272    H30255.ZICN  2013-11-06          500\u533b\u836f\n",
        "3273    H30257.OTER  2013-10-15          500\u4fe1\u606f\n",
        "3274    H30257.ZICN  2013-11-06          500\u4fe1\u606f\n",
        "3278    H30318.ZICN  2014-04-15         TMT150\n",
        "3302     HSC50.XHKG  2008-06-30         \u6052\u751f\u795e\u5dde50\n",
        "3308  HSCAT500.XHKG         NaN       \u6052\u751fA\u80a1500\u5f3a\n",
        "3513     NIFTY.XNSE         NaN     \u5370\u5ea6Nifty 50\n",
        "3623       SPX.ZIUS         NaN          \u6807\u666e500\n",
        "3624     SPXNT.ZIUS         NaN      \u6807\u666e500\u51c0\u603b\u6536\u76ca\n",
        "3625      SX5E.XXSC         NaN          \u65af\u6258\u514b50\n",
        "3636       VIX.XCBO         NaN    S&P 500 VIX"
       ]
      }
     ]
    },
    {
     "cell_type": "markdown",
     "id": "C2E03EC4107F4753B2E6D847AC7DF5C6",
     "metadata": {},
     "source": [
      "# \u5982\u4f55\u83b7\u53d6\u6307\u6570\u5185\u6807\u7684\u7ec6\u8282\uff0c\u5e76\u7528\u4e8e\u4ee3\u7801\u548c\u7b56\u7565"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": true,
     "id": "CCE27B3CF8DB438E884F87EFC357247D",
     "input": [
      "# \u83b7\u53d6\u6307\u6570\u4fe1\u606f\n",
      "index = get_asset('000016.ZICN')\n",
      "print index.exchange\n",
      "allstocks = index.get_components()\n",
      "allstocks"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "ZICN"
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n"
       ]
      },
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>symbol</th>\n",
        "      <th>name</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>600000.XSHG</td>\n",
        "      <td>\u6d66\u53d1\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td>600104.XSHG</td>\n",
        "      <td>\u4e0a\u6c7d\u96c6\u56e2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>600050.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u8054\u901a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>600036.XSHG</td>\n",
        "      <td>\u62db\u5546\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>600030.XSHG</td>\n",
        "      <td>\u4e2d\u4fe1\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td>600028.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u77f3\u5316</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td>600016.XSHG</td>\n",
        "      <td>\u6c11\u751f\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td>600519.XSHG</td>\n",
        "      <td>\u8d35\u5dde\u8305\u53f0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td>601006.XSHG</td>\n",
        "      <td>\u5927\u79e6\u94c1\u8def</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9</th>\n",
        "      <td>601398.XSHG</td>\n",
        "      <td>\u5de5\u5546\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td>600048.XSHG</td>\n",
        "      <td>\u4fdd\u5229\u5730\u4ea7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td>601628.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u4eba\u5bff</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td>601166.XSHG</td>\n",
        "      <td>\u5174\u4e1a\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td>601318.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u5e73\u5b89</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>601328.XSHG</td>\n",
        "      <td>\u4ea4\u901a\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td>601088.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u795e\u534e</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td>601857.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u77f3\u6cb9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td>601601.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u592a\u4fdd</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td>601169.XSHG</td>\n",
        "      <td>\u5317\u4eac\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td>600837.XSHG</td>\n",
        "      <td>\u6d77\u901a\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td>601668.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u5efa\u7b51</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td>601288.XSHG</td>\n",
        "      <td>\u519c\u4e1a\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td>601818.XSHG</td>\n",
        "      <td>\u5149\u5927\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td>600111.XSHG</td>\n",
        "      <td>\u5317\u65b9\u7a00\u571f</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td>601989.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u91cd\u5de5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td>601766.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u4e2d\u8f66</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td>600887.XSHG</td>\n",
        "      <td>\u4f0a\u5229\u80a1\u4efd</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td>601688.XSHG</td>\n",
        "      <td>\u534e\u6cf0\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td>600999.XSHG</td>\n",
        "      <td>\u62db\u5546\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td>600518.XSHG</td>\n",
        "      <td>\u5eb7\u7f8e\u836f\u4e1a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>30</th>\n",
        "      <td>601186.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u94c1\u5efa</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>31</th>\n",
        "      <td>601800.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u4ea4\u5efa</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>32</th>\n",
        "      <td>600958.XSHG</td>\n",
        "      <td>\u4e1c\u65b9\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>33</th>\n",
        "      <td>601390.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u4e2d\u94c1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>34</th>\n",
        "      <td>601988.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>35</th>\n",
        "      <td>601336.XSHG</td>\n",
        "      <td>\u65b0\u534e\u4fdd\u9669</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>36</th>\n",
        "      <td>601985.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u6838\u7535</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>37</th>\n",
        "      <td>601211.XSHG</td>\n",
        "      <td>\u56fd\u6cf0\u541b\u5b89</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>38</th>\n",
        "      <td>601788.XSHG</td>\n",
        "      <td>\u5149\u5927\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>39</th>\n",
        "      <td>600029.XSHG</td>\n",
        "      <td>\u5357\u65b9\u822a\u7a7a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>40</th>\n",
        "      <td>601901.XSHG</td>\n",
        "      <td>\u65b9\u6b63\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>41</th>\n",
        "      <td>601198.XSHG</td>\n",
        "      <td>\u4e1c\u5174\u8bc1\u5238</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>42</th>\n",
        "      <td>600100.XSHG</td>\n",
        "      <td>\u540c\u65b9\u80a1\u4efd</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>43</th>\n",
        "      <td>600547.XSHG</td>\n",
        "      <td>\u5c71\u4e1c\u9ec4\u91d1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>44</th>\n",
        "      <td>600485.XSHG</td>\n",
        "      <td>\u4fe1\u5a01\u96c6\u56e2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>45</th>\n",
        "      <td>600340.XSHG</td>\n",
        "      <td>\u534e\u590f\u5e78\u798f</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>46</th>\n",
        "      <td>601881.XSHG</td>\n",
        "      <td>\u4e2d\u56fd\u94f6\u6cb3</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>47</th>\n",
        "      <td>600919.XSHG</td>\n",
        "      <td>\u6c5f\u82cf\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>48</th>\n",
        "      <td>601229.XSHG</td>\n",
        "      <td>\u4e0a\u6d77\u94f6\u884c</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>49</th>\n",
        "      <td>600606.XSHG</td>\n",
        "      <td>\u7eff\u5730\u63a7\u80a1</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 17,
       "text": [
        "         symbol  name\n",
        "0   600000.XSHG  \u6d66\u53d1\u94f6\u884c\n",
        "1   600104.XSHG  \u4e0a\u6c7d\u96c6\u56e2\n",
        "2   600050.XSHG  \u4e2d\u56fd\u8054\u901a\n",
        "3   600036.XSHG  \u62db\u5546\u94f6\u884c\n",
        "4   600030.XSHG  \u4e2d\u4fe1\u8bc1\u5238\n",
        "5   600028.XSHG  \u4e2d\u56fd\u77f3\u5316\n",
        "6   600016.XSHG  \u6c11\u751f\u94f6\u884c\n",
        "7   600519.XSHG  \u8d35\u5dde\u8305\u53f0\n",
        "8   601006.XSHG  \u5927\u79e6\u94c1\u8def\n",
        "9   601398.XSHG  \u5de5\u5546\u94f6\u884c\n",
        "10  600048.XSHG  \u4fdd\u5229\u5730\u4ea7\n",
        "11  601628.XSHG  \u4e2d\u56fd\u4eba\u5bff\n",
        "12  601166.XSHG  \u5174\u4e1a\u94f6\u884c\n",
        "13  601318.XSHG  \u4e2d\u56fd\u5e73\u5b89\n",
        "14  601328.XSHG  \u4ea4\u901a\u94f6\u884c\n",
        "15  601088.XSHG  \u4e2d\u56fd\u795e\u534e\n",
        "16  601857.XSHG  \u4e2d\u56fd\u77f3\u6cb9\n",
        "17  601601.XSHG  \u4e2d\u56fd\u592a\u4fdd\n",
        "18  601169.XSHG  \u5317\u4eac\u94f6\u884c\n",
        "19  600837.XSHG  \u6d77\u901a\u8bc1\u5238\n",
        "20  601668.XSHG  \u4e2d\u56fd\u5efa\u7b51\n",
        "21  601288.XSHG  \u519c\u4e1a\u94f6\u884c\n",
        "22  601818.XSHG  \u5149\u5927\u94f6\u884c\n",
        "23  600111.XSHG  \u5317\u65b9\u7a00\u571f\n",
        "24  601989.XSHG  \u4e2d\u56fd\u91cd\u5de5\n",
        "25  601766.XSHG  \u4e2d\u56fd\u4e2d\u8f66\n",
        "26  600887.XSHG  \u4f0a\u5229\u80a1\u4efd\n",
        "27  601688.XSHG  \u534e\u6cf0\u8bc1\u5238\n",
        "28  600999.XSHG  \u62db\u5546\u8bc1\u5238\n",
        "29  600518.XSHG  \u5eb7\u7f8e\u836f\u4e1a\n",
        "30  601186.XSHG  \u4e2d\u56fd\u94c1\u5efa\n",
        "31  601800.XSHG  \u4e2d\u56fd\u4ea4\u5efa\n",
        "32  600958.XSHG  \u4e1c\u65b9\u8bc1\u5238\n",
        "33  601390.XSHG  \u4e2d\u56fd\u4e2d\u94c1\n",
        "34  601988.XSHG  \u4e2d\u56fd\u94f6\u884c\n",
        "35  601336.XSHG  \u65b0\u534e\u4fdd\u9669\n",
        "36  601985.XSHG  \u4e2d\u56fd\u6838\u7535\n",
        "37  601211.XSHG  \u56fd\u6cf0\u541b\u5b89\n",
        "38  601788.XSHG  \u5149\u5927\u8bc1\u5238\n",
        "39  600029.XSHG  \u5357\u65b9\u822a\u7a7a\n",
        "40  601901.XSHG  \u65b9\u6b63\u8bc1\u5238\n",
        "41  601198.XSHG  \u4e1c\u5174\u8bc1\u5238\n",
        "42  600100.XSHG  \u540c\u65b9\u80a1\u4efd\n",
        "43  600547.XSHG  \u5c71\u4e1c\u9ec4\u91d1\n",
        "44  600485.XSHG  \u4fe1\u5a01\u96c6\u56e2\n",
        "45  600340.XSHG  \u534e\u590f\u5e78\u798f\n",
        "46  601881.XSHG  \u4e2d\u56fd\u94f6\u6cb3\n",
        "47  600919.XSHG  \u6c5f\u82cf\u94f6\u884c\n",
        "48  601229.XSHG  \u4e0a\u6d77\u94f6\u884c\n",
        "49  600606.XSHG  \u7eff\u5730\u63a7\u80a1"
       ]
      }
     ]
    },
    {
     "cell_type": "markdown",
     "id": "78064D8F224C46D186FA76ADE3F7DA28",
     "metadata": {},
     "source": [
      "# \u5982\u4f55\u8c03\u53d6\u6307\u6570\u6570\u636e\uff0c\u7528\u4e8e\u6570\u636e\u5904\u7406\u6216\u4e0b\u8f7d"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "id": "B645DC58AC2E402A8CB0AA85493FEE69",
     "input": [
      "DataAPI.MktIdxdGet(tradeDate=u\"20150417\",indexID=u\"851931.ZICN\",ticker=u\"\",beginDate=u\"\",endDate=u\"\",exchangeCD=u\"XSHE,XSHG\",field=u\"\",pandas=\"1\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>indexID</th>\n",
        "      <th>ticker</th>\n",
        "      <th>porgFullName</th>\n",
        "      <th>secShortName</th>\n",
        "      <th>exchangeCD</th>\n",
        "      <th>tradeDate</th>\n",
        "      <th>preCloseIndex</th>\n",
        "      <th>openIndex</th>\n",
        "      <th>lowestIndex</th>\n",
        "      <th>highestIndex</th>\n",
        "      <th>closeIndex</th>\n",
        "      <th>turnoverVol</th>\n",
        "      <th>turnoverValue</th>\n",
        "      <th>CHG</th>\n",
        "      <th>CHGPct</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>851931.ZICN</td>\n",
        "      <td>851931</td>\n",
        "      <td>\u4e0a\u6d77\u7533\u94f6\u4e07\u56fd\u8bc1\u5238\u7814\u7a76\u6240\u6709\u9650\u516c\u53f8</td>\n",
        "      <td>\u7533\u94f6\u4e07\u56fd\u6307\u6570-\u8bc1\u5238</td>\n",
        "      <td>XSHG</td>\n",
        "      <td>2015-04-17</td>\n",
        "      <td>13204.11</td>\n",
        "      <td>13348.09</td>\n",
        "      <td>13116.57</td>\n",
        "      <td>13655.42</td>\n",
        "      <td>13308.28</td>\n",
        "      <td>3578840000</td>\n",
        "      <td>94408550000</td>\n",
        "      <td>104.17</td>\n",
        "      <td>0.00789</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 25,
       "text": [
        "       indexID  ticker     porgFullName secShortName exchangeCD   tradeDate  \\\n",
        "0  851931.ZICN  851931  \u4e0a\u6d77\u7533\u94f6\u4e07\u56fd\u8bc1\u5238\u7814\u7a76\u6240\u6709\u9650\u516c\u53f8    \u7533\u94f6\u4e07\u56fd\u6307\u6570-\u8bc1\u5238       XSHG  2015-04-17   \n",
        "\n",
        "   preCloseIndex  openIndex  lowestIndex  highestIndex  closeIndex  \\\n",
        "0       13204.11   13348.09     13116.57      13655.42    13308.28   \n",
        "\n",
        "   turnoverVol  turnoverValue     CHG   CHGPct  \n",
        "0   3578840000    94408550000  104.17  0.00789  "
       ]
      }
     ]
    },
    {
     "cell_type": "code",
     "collapsed": true,
     "id": "0834EF727E6944E8BDED63A1FD88991D",
     "input": [
      "DataAPI.MktIdxdGet(tradeDate=u\"20150417\",indexID=u\"801193.ZICN\",ticker=u\"\",beginDate=u\"\",endDate=u\"\",exchangeCD=u\"XSHE,XSHG\",field=u\"\",pandas=\"1\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>indexID</th>\n",
        "      <th>ticker</th>\n",
        "      <th>porgFullName</th>\n",
        "      <th>secShortName</th>\n",
        "      <th>exchangeCD</th>\n",
        "      <th>tradeDate</th>\n",
        "      <th>preCloseIndex</th>\n",
        "      <th>openIndex</th>\n",
        "      <th>lowestIndex</th>\n",
        "      <th>highestIndex</th>\n",
        "      <th>closeIndex</th>\n",
        "      <th>turnoverVol</th>\n",
        "      <th>turnoverValue</th>\n",
        "      <th>CHG</th>\n",
        "      <th>CHGPct</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 24,
       "text": [
        "Empty DataFrame\n",
        "Columns: [indexID, ticker, porgFullName, secShortName, exchangeCD, tradeDate, preCloseIndex, openIndex, lowestIndex, highestIndex, closeIndex, turnoverVol, turnoverValue, CHG, CHGPct]\n",
        "Index: []"
       ]
      }
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "id": "D3B82673BE254EAD8F772ED6DB8EE709",
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}